SELECT Id FROM new_searchtable
where town = 'Manchester' and state='NH' and type ='T'
AND list_price BETWEEN '150000' AND '250000'
ORDER BY list_price Desc
Manchester NH Condos page 5
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Welcome to Brookchester Row, where urban living meets modern luxury in the heart of the Queen City! This recently renovated turnkey penthouse offers a sleek open-concept design, perfect for contemporary living. Step inside this spacious loft-style townhouse to discover new hardwood floors, cabinets, and windows, complemented by a fresh professional paint job. Located just steps away from the vibrant city life, residents can indulge in an array of dining, shopping, and nightlife options right outside their door. Experience the excitement of live events at SHNU Arena or catch a ballgame at Delta Dental Stadium, all within reach of this prime location. With a low monthly condo fee, convenience is key with indoor basement access to coin-operated laundry and off-street parking including one deed parking spot and permit street parking for a second vehicle. Plus, this pet-friendly association makes it easy to settle in with your furry companions. Sold fully furnished, this move-in-ready unit is not only an ideal home but also a fantastic investment opportunity. Don't miss your chance, seize the opportunity for urban living at its finest!
Description:New Price! Offer Deadline Monday 2/10 1pm. Incredible opportunity to own in highly sought after Oak Brook Estates! These properties do not come available often! Enjoy maintenance free living in an unbeatable location and all for an unbeatable price! Nice larger unit features a balcony overlooking mature landscaping in this enchanting community and a smooth flowing, modern living space. This one of a kind development not only offers the most esthetically pleasing grounds you will ever find but also has many amenities for the active owner. Break from hot summer days by the pool and club house, or start your routine with a daily workout in the community exercise room. The Basketball and Tennis Courts are just waiting for you around the corner. Also not to make enjoying yourself too convenient but Oak Brook Estates actually abuts Intervale Country Club! All that aside, this place is gorgeous! Heat and Hot Water included in low HOA. Exceptionally clean and well manicured area. Only minutes to shopping and amenities, 1.5 miles from I-93 and 1 mile from I-293 (straight shot either way) easy for the commuter. This one will go quick!